package com.cdp.system.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.cdp.common.core.domain.entity.*;
import com.cdp.system.dto.MechanicalPerformanceQueryDTO;
import com.cdp.system.dto.MechanicalPerformanceQueryDTOSecond;
import com.cdp.system.mapper.SysCementMapper;
import com.cdp.system.mapper.SysMechanicalPerformanceMapper;
import com.cdp.system.service.*;
import com.cdp.system.vo.*;
import com.google.common.base.Function;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.math.BigDecimal;
import java.util.*;
import java.util.stream.Collectors;
import java.util.stream.Stream;

@Service
public class SysMechanicalPerformanceServiceImpl extends ServiceImpl<SysMechanicalPerformanceMapper, SysMechanicalPerformance> implements ISysMechanicalPerformanceService {


    @Autowired
    private SysMechanicalPerformanceMapper sysMechanicalPerformanceMapper;

    @Autowired
    private SysCementMapper sysCementMapper;


    @Autowired
    private IsysRegionService isysRegionService;
    @Autowired
    private ISysFlyashService sysFlyashService;

    @Autowired
    private ISysSandFinenesService sysSandFinenesService;

    @Autowired
    private ISysSandTypeService sysSandTypeService;

    @Autowired
    private ISysSandService sysSandService;

    @Autowired
    private ISysStoneGrainService sysStoneGrainService;

    @Autowired
    private ISysFlyashTypeService sysFlyashTypeService;

    @Autowired
    private ISysFlyashFinenessService sysFlyashFinenessService;

    @Autowired
    private ISysWaterReducerTypeService sysWaterReducerTypeService;

    @Autowired
    private ISysCementService sysCementService;

    @Autowired
    private ISysStoneService sysStoneService;

    @Autowired
    private ISysWaterReducerService sysWaterReducerService;

    @Autowired
    private ISysStoneSizeService stoneSizeService;

    @Autowired
    private ISysSourceNameService sysSourceNameService;
    @Autowired
    private ISysEfficiencyMerchantNameService sysEfficiencyMerchantNameService;


    @Autowired
    private ISysDeformationPerformanceService sysDeformationPerformanceService;

    @Autowired
    private ISysEfficiencyAgentService sysEfficiencyAgent;

    @Autowired
    private ISysDurabilityPerformanceService sysDurabilityPerformanceService;

    @Autowired
    private ISysWaterService waterService;

    @Autowired
    private ISysMineralPowderService sysMineralPowderService;

    @Autowired
    private SysOtherAdmixturesService sysOtherAdmixturesService;


    @Autowired
    private ISysWaterModelService sysWaterModelService;

    @Autowired
    private ISysSwellingagentService sysSwellingagentService;


    @Override
    public List<SysMechanicalPerformance> listSysMechanicalPerformance() {
        List<SysMechanicalPerformance> list = list();
        return list;
    }


//  好的  @Override
//    public List<MechanicalPerformanceQueryVO> queryMistedMechanicalPerformance(MechanicalPerformanceQueryDTO mechanicalPerformanceQueryDTO) {
//        // Step 1: 调用 Mapper 获取查询结果
//        List<MechanicalPerformanceQueryVO> mechanicalPerformanceList = sysMechanicalPerformanceMapper.selectByCondition(mechanicalPerformanceQueryDTO);
//
//
//        // Step 2: 预加载相关数据，减少循环中查询，转换 Integer -> Long
//        Map<Long, SysWater> waterMap = waterService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysWater -> sysWater.getWaterId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysCement> cementMap = sysCementService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysCement -> sysCement.getCementId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysStone> stoneMap = sysStoneService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysStone -> sysStone.getStoneId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysSand> sandMap = sysSandService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysSand -> sysSand.getSandId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysFlyash> flyashMap = sysFlyashService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysFlyash -> sysFlyash.getFlyashId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysWaterReducer> reducerMap = sysWaterReducerService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysWaterReducer -> sysWaterReducer.getReducerId().longValue(),
//                        item -> item
//                ));
//
//
//        Map<Long, SysEfficiencyAgent> efficiencyAgentMap = sysEfficiencyAgent.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysEfficiencyAgent -> sysEfficiencyAgent.getAgentId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysMineralPowder> mineralPowderMap = sysMineralPowderService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysMineralPowder -> sysMineralPowder.getPowderId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysOtherAdmixtures> otherAdmixturesMap = sysOtherAdmixturesService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        sysOtherAdmixtures -> sysOtherAdmixtures.getAdmixturesId().longValue(),
//                        item -> item
//                ));
//
//        Map<Long, SysSwellingagent> swellingagentMap = sysSwellingagentService.list()
//                .stream()
//                .collect(Collectors.toMap(
//                        swellingagent -> swellingagent.getSwellingagentId().longValue(),
//                        item -> item
//                ));
//
//        // Step 3: 填充数据
//        List<MechanicalPerformanceQueryVO> mechanicalList = mechanicalPerformanceList.stream().map(entity -> {
//            MechanicalPerformanceQueryVO vo = new MechanicalPerformanceQueryVO();
//            BeanUtils.copyProperties(entity, vo);
//
//            //矿粉量
//            //其他参合料量
//            //膨胀剂用量
//
//
//
//            // 设置水数据
//            if (entity.getWaterId() != null) {
//                SysWater sysWater = waterMap.get(entity.getWaterId());
//                if (sysWater != null) {
//                    SysWaterVO sysWaterVO = new SysWaterVO();
//                    BeanUtils.copyProperties(sysWater, sysWaterVO);
//                    vo.setWaterModel(sysWater.getModel());
//                    vo.setSysWaterVO(sysWaterVO);
//                }
//            }
//
//            // 设置水泥数据
//            if (entity.getCementId() != null) {
//                SysCement sysCement = cementMap.get(entity.getCementId());
//                if (sysCement != null) {
//                    SysCementVO sysCementVO = new SysCementVO();
//                    BeanUtils.copyProperties(sysCement, sysCementVO);
//                    vo.setSysCementVO(sysCementVO);
//                    vo.setCementModel(sysCementVO.getModel());
//                }
//            }
//
//            // 设置石头数据
//            if (entity.getStoneId() != null) {
//                SysStone sysStone = stoneMap.get(entity.getStoneId());
//                if (sysStone != null) {
//                    SysStoneVO sysStoneVO = new SysStoneVO();
//                    BeanUtils.copyProperties(sysStone, sysStoneVO);
//                    vo.setSysStoneVO(sysStoneVO);
//                    vo.setStoneModel(sysStoneVO.getModel());
//
//                }
//            }
//
//            // 设置砂数据
//            if (entity.getSandId() != null) {
//                SysSand sysSand = sandMap.get(entity.getSandId());
//                if (sysSand != null) {
//                    SysSandVO sysSandVO = new SysSandVO();
//                    BeanUtils.copyProperties(sysSand, sysSandVO);
//                    vo.setSysSandVO(sysSandVO);
//                    vo.setSandModel(sysSandVO.getType());
//                }
//            }
//
//            // 设置粉煤灰数据
//            if (entity.getFlyashId() != null) {
//                SysFlyash sysFlyash = flyashMap.get(entity.getFlyashId());
//                if (sysFlyash != null) {
//                    SysFlyashVO sysFlyashVO = new SysFlyashVO();
//                    BeanUtils.copyProperties(sysFlyash, sysFlyashVO);
//                    vo.setSysFlyashVO(sysFlyashVO);
//                    vo.setFlyModel(sysFlyashVO.getGrade());
//                }
//            }
//
//            // 设置减水剂数据
//            if (entity.getReducerId() != null) {
//                SysWaterReducer sysWaterReducer = reducerMap.get(Long.valueOf(entity.getReducerId()));
//                if (sysWaterReducer != null) {
//                    AdditiveWaterReducerVO waterReducerVO = new AdditiveWaterReducerVO();
//                    BeanUtils.copyProperties(sysWaterReducer, waterReducerVO);
//                    vo.setAdditiveWaterReducerVO(waterReducerVO);
//                    vo.setWaterReducerModel(waterReducerVO.getModel());
//
//                }
//            }
//
//            // 设置增效剂数据
//            if (entity.getAgentId() != null) {
//                SysEfficiencyAgent sysEfficiencyAgent = efficiencyAgentMap.get(entity.getAgentId());
//                if (sysEfficiencyAgent != null) {
//                    SysEfficiencyAgentVO sysEfficiencyAgentVO = new SysEfficiencyAgentVO();
//                    BeanUtils.copyProperties(sysEfficiencyAgent, sysEfficiencyAgentVO);
//                    vo.setSysEfficiencyAgentVO(sysEfficiencyAgentVO);
//                    vo.setAgentModel(sysEfficiencyAgent.getModel());
//
//                }
//            }
//
//            // 设置矿粉数据
//            if (entity.getPowderId() != null) {
//                SysMineralPowder sysMineralPowder = mineralPowderMap.get(Long.valueOf(entity.getPowderId()));
//                if (sysMineralPowder != null) {
//                    SysMineralPowderVO sysMineralPowderVO = new SysMineralPowderVO();
//                    BeanUtils.copyProperties(sysMineralPowder, sysMineralPowderVO);
//                    vo.setMineralPowderVO(sysMineralPowderVO);
//                    vo.setMineralPowderModel(sysMineralPowderVO.getModel());
//                }
//            }
//
//            // 设置其他数据
//            if (entity.getAdmixturesId() != null) {
//                SysOtherAdmixtures sysOtherAdmixtures = otherAdmixturesMap.get(Long.valueOf(entity.getAdmixturesId()));
//                if (sysOtherAdmixtures != null) {
//                    SysOtherAdmixturesVO sysOtherAdmixturesVO = new SysOtherAdmixturesVO();
//                    BeanUtils.copyProperties(sysOtherAdmixtures, sysOtherAdmixturesVO);
//                    vo.setSysOtherAdmixturesVO(sysOtherAdmixturesVO);
//                    vo.setOtherAdmixturesModel(sysOtherAdmixturesVO.getModel());
//                }
//            }
//
//            // 设置膨胀剂数据
//            if (entity.getSwellingagentId() != null) {
//                SysSwellingagent sysSwellingagent = swellingagentMap.get(entity.getSwellingagentId().longValue());
//                if (sysSwellingagent != null) {
//                    SwellingagentVO swellingagentVO = new SwellingagentVO();
//                    BeanUtils.copyProperties(sysSwellingagent, swellingagentVO);
//                    vo.setSwellingagentVO(swellingagentVO);
//                    vo.setSwellingagentModel(swellingagentVO.getModel());
//                }
//            }
//
//
//
//            return vo;
//        }).collect(Collectors.toList());
//
//        // 返回处理后的结果列表
//        return mechanicalList;
//    }


    @Override
    public List<MechanicalPerformanceQueryVO> queryMistedMechanicalPerformance(MechanicalPerformanceQueryDTO mechanicalPerformanceQueryDTO) {
        // Step 1: 调用 Mapper 获取查询结果，返回 List<MechanicalPerformanceQueryVO>
        List<MechanicalPerformanceQueryVO> mechanicalPerformanceList = sysMechanicalPerformanceMapper.selectByCondition(mechanicalPerformanceQueryDTO);

        // Step 2: 预加载相关数据，减少循环中查询，转换 Integer -> Long
        Map<Long, SysWater> waterMap = waterService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysWater -> sysWater.getWaterId().longValue(),
                        item -> item
                ));

        Map<Long, SysCement> cementMap = sysCementService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysCement -> sysCement.getCementId().longValue(),
                        item -> item
                ));

        Map<Long, SysStone> stoneMap = sysStoneService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysStone -> sysStone.getStoneId().longValue(),
                        item -> item
                ));

        Map<Long, SysSand> sandMap = sysSandService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysSand -> sysSand.getSandId().longValue(),
                        item -> item
                ));

        Map<Long, SysFlyash> flyashMap = sysFlyashService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysFlyash -> sysFlyash.getFlyashId().longValue(),
                        item -> item
                ));

        Map<Long, SysWaterReducer> reducerMap = sysWaterReducerService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysWaterReducer -> sysWaterReducer.getReducerId().longValue(),
                        item -> item
                ));

        Map<Long, SysEfficiencyAgent> efficiencyAgentMap = sysEfficiencyAgent.list()
                .stream()
                .collect(Collectors.toMap(
                        sysEfficiencyAgent -> sysEfficiencyAgent.getAgentId().longValue(),
                        item -> item
                ));

        Map<Long, SysMineralPowder> mineralPowderMap = sysMineralPowderService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysMineralPowder -> sysMineralPowder.getPowderId().longValue(),
                        item -> item
                ));

        Map<Long, SysOtherAdmixtures> otherAdmixturesMap = sysOtherAdmixturesService.list()
                .stream()
                .collect(Collectors.toMap(
                        sysOtherAdmixtures -> sysOtherAdmixtures.getAdmixturesId().longValue(),
                        item -> item
                ));

        Map<Long, SysSwellingagent> swellingagentMap = sysSwellingagentService.list()
                .stream()
                .collect(Collectors.toMap(
                        swellingagent -> swellingagent.getSwellingagentId().longValue(),
                        item -> item
                ));

        // Step 3: 填充数据
        List<MechanicalPerformanceQueryVO> mechanicalList = mechanicalPerformanceList.stream().map(vo -> {
            // 直接使用 mechanicalPerformanceList 中的 VO 进行处理，不再需要 BeanUtils.copyProperties()

            // 矿粉量
            if (vo.getPowderId() != null) {
                SysMineralPowder sysMineralPowder = mineralPowderMap.get(Long.valueOf(vo.getPowderId()));
                if (sysMineralPowder != null) {
                    SysMineralPowderVO sysMineralPowderVO = new SysMineralPowderVO();
                    BeanUtils.copyProperties(sysMineralPowder, sysMineralPowderVO);
                    vo.setMineralPowderVO(sysMineralPowderVO);
                    vo.setMineralPowderModel(sysMineralPowderVO.getModel());
                }
            }

            // 其他参合料量
            if (vo.getAdmixturesId() != null) {
                SysOtherAdmixtures sysOtherAdmixtures = otherAdmixturesMap.get(Long.valueOf(vo.getAdmixturesId()));
                if (sysOtherAdmixtures != null) {
                    SysOtherAdmixturesVO sysOtherAdmixturesVO = new SysOtherAdmixturesVO();
                    BeanUtils.copyProperties(sysOtherAdmixtures, sysOtherAdmixturesVO);
                    vo.setSysOtherAdmixturesVO(sysOtherAdmixturesVO);
                    vo.setOtherAdmixturesModel(sysOtherAdmixturesVO.getModel());
                }
            }

            // 膨胀剂用量
            if (vo.getSwellingagentId() != null) {
                SysSwellingagent sysSwellingagent = swellingagentMap.get(vo.getSwellingagentId().longValue());
                if (sysSwellingagent != null) {
                    SwellingagentVO swellingagentVO = new SwellingagentVO();
                    BeanUtils.copyProperties(sysSwellingagent, swellingagentVO);
                    vo.setSwellingagentVO(swellingagentVO);
                    vo.setSwellingagentModel(swellingagentVO.getModel());
                }
            }

            // 设置水数据
            if (vo.getWaterId() != null) {
                SysWater sysWater = waterMap.get(vo.getWaterId());
                if (sysWater != null) {
                    SysWaterVO sysWaterVO = new SysWaterVO();
                    BeanUtils.copyProperties(sysWater, sysWaterVO);
                    vo.setWaterModel(sysWater.getModel());
                    vo.setSysWaterVO(sysWaterVO);
                }
            }

            // 设置水泥数据
            if (vo.getCementId() != null) {
                SysCement sysCement = cementMap.get(vo.getCementId());
                if (sysCement != null) {
                    SysCementVO sysCementVO = new SysCementVO();
                    BeanUtils.copyProperties(sysCement, sysCementVO);
                    vo.setSysCementVO(sysCementVO);
                    vo.setCementModel(sysCementVO.getModel());
                }
            }

            // 设置石头数据
            if (vo.getStoneId() != null) {
                SysStone sysStone = stoneMap.get(vo.getStoneId());
                if (sysStone != null) {
                    SysStoneVO sysStoneVO = new SysStoneVO();
                    BeanUtils.copyProperties(sysStone, sysStoneVO);
                    vo.setSysStoneVO(sysStoneVO);
                    vo.setStoneModel(sysStoneVO.getModel());
                }
            }

            // 设置砂数据
            if (vo.getSandId() != null) {
                SysSand sysSand = sandMap.get(vo.getSandId());
                if (sysSand != null) {
                    SysSandVO sysSandVO = new SysSandVO();
                    BeanUtils.copyProperties(sysSand, sysSandVO);
                    vo.setSysSandVO(sysSandVO);
                    vo.setSandModel(sysSandVO.getType());
                }
            }

            // 设置粉煤灰数据
            if (vo.getFlyashId() != null) {
                SysFlyash sysFlyash = flyashMap.get(vo.getFlyashId());
                if (sysFlyash != null) {
                    SysFlyashVO sysFlyashVO = new SysFlyashVO();
                    BeanUtils.copyProperties(sysFlyash, sysFlyashVO);
                    vo.setSysFlyashVO(sysFlyashVO);
                    vo.setFlyModel(sysFlyashVO.getGrade());
                }
            }

            // 设置减水剂数据
            if (vo.getReducerId() != null) {
                SysWaterReducer sysWaterReducer = reducerMap.get(Long.valueOf(vo.getReducerId()));
                if (sysWaterReducer != null) {
                    AdditiveWaterReducerVO waterReducerVO = new AdditiveWaterReducerVO();
                    BeanUtils.copyProperties(sysWaterReducer, waterReducerVO);
                    vo.setAdditiveWaterReducerVO(waterReducerVO);
                    vo.setWaterReducerModel(waterReducerVO.getModel());
                }
            }

            // 设置增效剂数据
            if (vo.getAgentId() != null) {
                SysEfficiencyAgent sysEfficiencyAgent = efficiencyAgentMap.get(vo.getAgentId());
                if (sysEfficiencyAgent != null) {
                    SysEfficiencyAgentVO sysEfficiencyAgentVO = new SysEfficiencyAgentVO();
                    BeanUtils.copyProperties(sysEfficiencyAgent, sysEfficiencyAgentVO);
                    vo.setSysEfficiencyAgentVO(sysEfficiencyAgentVO);
                    vo.setAgentModel(sysEfficiencyAgent.getModel());
                }
            }

            return vo;
        }).collect(Collectors.toList());

        // 返回处理后的结果列表
        return mechanicalList;
    }


    /**
     * 查询
     *
     * @param mechanicalIds
     * @return
     */
    @Override
    public List<SysMechanicalPerformance> exportMechanicalPerformance(List<Integer> mechanicalIds) {
        if (mechanicalIds == null || mechanicalIds.isEmpty()) {
            return Collections.emptyList();
        }
        List<SysMechanicalPerformance> sysMechanicalPerformanceList = sysMechanicalPerformanceMapper.exportMechanicalPerformance(mechanicalIds);

        return sysMechanicalPerformanceList;
    }

    @Override
    @Transactional
    public List<MechanicalPerformanceQueryVOSecond> queryMistedMechanicalPerformanceSecond(MechanicalPerformanceQueryDTOSecond mechanicalPerformanceQueryDTOSecond) {
        List<MechanicalPerformanceQueryVOSecond> queryVOSeconds = sysMechanicalPerformanceMapper.queryMistedMechanicalPerformanceSecond(mechanicalPerformanceQueryDTOSecond);

        int size = queryVOSeconds.size();
        for (MechanicalPerformanceQueryVOSecond queryVOSecond : queryVOSeconds) {
            queryVOSecond.setSize(size);

            SysCementVO sysCementVO = new SysCementVO();

            sysCementVO.setCementId(queryVOSecond.getScCementId());
            sysCementVO.setModel(queryVOSecond.getScModel());
            sysCementVO.setRegionName(queryVOSecond.getScRegionName());
            sysCementVO.setRegionNameStr(queryVOSecond.getScregionNameStr());
            sysCementVO.setStrengthGrade(queryVOSecond.getScStrengthGrade());
            sysCementVO.setCaoContent(queryVOSecond.getScCaoContent());
            sysCementVO.setSio2Content(queryVOSecond.getScSio2Content());
            sysCementVO.setAl2o3Content(queryVOSecond.getScAl2o3content());
            sysCementVO.setCompressiveStrength28d(queryVOSecond.getScCompressiveStrength28d());


            queryVOSecond.setSysCementVO(sysCementVO);

            // 获取 Stond510VO 对象
            Stond510VO stond510VO = new Stond510VO();
            stond510VO.setStoneId(queryVOSecond.getStoneId510());//石头id
            stond510VO.setModel(queryVOSecond.getModel510());//石头型号
            stond510VO.setRegionName(queryVOSecond.getRegionName510());//地区id
//            stond510VO.setRegionNameStr(queryVOSecond.getRegionNameStr510());//地区名称
            stond510VO.setStoneSpecification(queryVOSecond.getStoneSpecification510());//石子规格
            stond510VO.setStackingDensity(queryVOSecond.getStackingDensity510());//石头堆积密度
            stond510VO.setCompactDensity(queryVOSecond.getCompactDensity510());//石头精密密度
            stond510VO.setBulkDensity(queryVOSecond.getBulkdensity510());//石头表观密度
            queryVOSecond.setStond510VO(stond510VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中


            // 获取 Stond525VO 对象
            Stond525VO stond525VO = new Stond525VO();
            stond525VO.setStoneId(queryVOSecond.getStoneId525());//石头id
            stond525VO.setModel(queryVOSecond.getModel525());//石头型号
            stond525VO.setRegionName(queryVOSecond.getRegionName525());//地区id
//            stond525VO.setRegionNameStr(queryVOSecond.getRegionNameStr525());//地区名称
            stond525VO.setStoneSpecification(queryVOSecond.getStoneSpecification525());//石子规格
            stond525VO.setStackingDensity(queryVOSecond.getStackingDensity525());//石头堆积密度
            stond525VO.setCompactDensity(queryVOSecond.getCompactDensity525());//石头精密密度
            stond525VO.setBulkDensity(queryVOSecond.getBulkdensity525());//石头表观密度
            queryVOSecond.setStond525VO(stond525VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中


            // 获取 Stond2040VO 对象
            Stond2040VO stond2040VO = new Stond2040VO();
            stond2040VO.setStoneId(queryVOSecond.getStoneId2040());//石头id
            stond2040VO.setModel(queryVOSecond.getModel2040());//石头型号
            stond2040VO.setRegionName(queryVOSecond.getRegionName2040());//地区id
            stond2040VO.setRegionNameStr(queryVOSecond.getRegionNameStr2040());//地区名称
            stond2040VO.setStoneSpecification(queryVOSecond.getStoneSpecification2040());//石子规格
            stond2040VO.setStackingDensity(queryVOSecond.getStackingDensity2040());//石头堆积密度
            stond2040VO.setCompactDensity(queryVOSecond.getCompactDensity2040());//石头精密密度
            stond2040VO.setBulkDensity(queryVOSecond.getBulkdensity2040());//石头表观密度
            queryVOSecond.setStond2040VO(stond2040VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中



            // 获取 Stond2040VO 对象
            Stond1020VO stond1020VO = new Stond1020VO();
            stond1020VO.setStoneId(queryVOSecond.getStoneId1020());//石头id
            stond1020VO.setModel(queryVOSecond.getModel1020());//石头型号
            stond1020VO.setRegionName(queryVOSecond.getRegionName1020());//地区id
            stond1020VO.setRegionNameStr(queryVOSecond.getRegionNameStr1020());//地区名称
            stond1020VO.setStoneSpecification(queryVOSecond.getStoneSpecification1020());//石子规格
            stond1020VO.setStackingDensity(queryVOSecond.getStackingDensity1020());//石头堆积密度
            stond1020VO.setCompactDensity(queryVOSecond.getCompactDensity1020());//石头精密密度
            stond1020VO.setBulkDensity(queryVOSecond.getBulkdensity1020());//石头表观密度
            queryVOSecond.setStond1020VO(stond1020VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中




            // 获取 Stond1030VO 对象
            Stond1030VO stond1030VO = new Stond1030VO();
            stond1030VO.setStoneId(queryVOSecond.getStoneId1030());//石头id
            stond1030VO.setModel(queryVOSecond.getModel1030());//石头型号
            stond1030VO.setRegionName(queryVOSecond.getRegionName1030());//地区id
            stond1030VO.setRegionNameStr(queryVOSecond.getRegionNameStr1030());//地区名称
            stond1030VO.setStoneSpecification(queryVOSecond.getStoneSpecification1030());//石子规格
            stond1030VO.setStackingDensity(queryVOSecond.getStackingDensity1030());//石头堆积密度
            stond1030VO.setCompactDensity(queryVOSecond.getCompactDensity1030());//石头精密密度
            stond1030VO.setBulkDensity(queryVOSecond.getBulkdensity1030());//石头表观密度
            queryVOSecond.setStond1030VO(stond1030VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中


            // 获取 Stond1030VO 对象
            Stond010VO stond010VO = new Stond010VO();
            stond010VO.setStoneId(queryVOSecond.getStoneId010());//石头id
            stond010VO.setModel(queryVOSecond.getModel010());//石头型号
            stond010VO.setRegionName(queryVOSecond.getRegionName010());//地区id
            stond010VO.setRegionNameStr(queryVOSecond.getRegionNameStr010());//地区名称
            stond010VO.setStoneSpecification(queryVOSecond.getStoneSpecification010());//石子规格
            stond010VO.setStackingDensity(queryVOSecond.getStackingDensity010());//石头堆积密度
            stond010VO.setCompactDensity(queryVOSecond.getCompactDensity010());//石头精密密度
            stond010VO.setBulkDensity(queryVOSecond.getBulkdensity010());//石头表观密度
            queryVOSecond.setStond010VO(stond010VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中



            // 获取 Stond1030VO 对象
            Stond2030VO stond2030VO = new Stond2030VO();
            stond2030VO.setStoneId(queryVOSecond.getStoneId2030());//石头id
            stond2030VO.setModel(queryVOSecond.getModel2030());//石头型号
            stond2030VO.setRegionName(queryVOSecond.getRegionName2030());//地区id
            stond2030VO.setRegionNameStr(queryVOSecond.getRegionNameStr2030());//地区名称
            stond2030VO.setStoneSpecification(queryVOSecond.getStoneSpecification2030());//石子规格
            stond2030VO.setStackingDensity(queryVOSecond.getStackingDensity2030());//石头堆积密度
            stond2030VO.setCompactDensity(queryVOSecond.getCompactDensity2030());//石头精密密度
            stond2030VO.setBulkDensity(queryVOSecond.getBulkdensity2030());//石头表观密度
            queryVOSecond.setStond2030VO(stond2030VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中



            //砂
            SandRiverCoarse3137VO sandRiverCoarse3137VO = new SandRiverCoarse3137VO();
            sandRiverCoarse3137VO.setSandId(queryVOSecond.getSandRiverCoarse3137Id());/*砂id*/
            sandRiverCoarse3137VO.setType(queryVOSecond.getModelSandRiverCoarse3137());/*砂类型*/
            sandRiverCoarse3137VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse3137());/*地区id*/
            sandRiverCoarse3137VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse3137());/*地区名称*/
            sandRiverCoarse3137VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse3137());/*分布*/
            sandRiverCoarse3137VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse3137());/*细度*/
            sandRiverCoarse3137VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse3137());/*堆积密度*/
            sandRiverCoarse3137VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse3137());/*精密密度*/
            sandRiverCoarse3137VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse3137());/*表观密度*/
            queryVOSecond.setSandRiverCoarse3137VO(sandRiverCoarse3137VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中





            SandRiverCoarse2030VO sandRiverCoarse2330VO = new SandRiverCoarse2030VO();
            sandRiverCoarse2330VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse2330());/*砂id*/
            sandRiverCoarse2330VO.setType(queryVOSecond.getModelSandRiverCoarse2330());/*砂类型*/
            sandRiverCoarse2330VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse2330());/*地区id*/
            sandRiverCoarse2330VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse2330());/*地区名称*/
            sandRiverCoarse2330VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse2330());/*分布*/
            sandRiverCoarse2330VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse2330());/*细度*/
            sandRiverCoarse2330VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse2330());/*堆积密度*/
            sandRiverCoarse2330VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse2330());/*精密密度*/
            sandRiverCoarse2330VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse2330());/*表观密度*/
            queryVOSecond.setSandRiverCoarse2330VO(sandRiverCoarse2330VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中






            SandRiverCoarse1622VO sandRiverCoarse1622VO = new SandRiverCoarse1622VO();
            sandRiverCoarse1622VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse1622());/*砂id*/
            sandRiverCoarse1622VO.setType(queryVOSecond.getModelSandRiverCoarse1622());/*砂类型*/
            sandRiverCoarse1622VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse1622());/*地区id*/
            sandRiverCoarse1622VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse1622());/*地区名称*/
            sandRiverCoarse1622VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse1622());/*分布*/
            sandRiverCoarse1622VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse1622());/*细度*/
            sandRiverCoarse1622VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse1622());/*堆积密度*/
            sandRiverCoarse1622VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse1622());/*精密密度*/
            sandRiverCoarse1622VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse1622());/*表观密度*/
            queryVOSecond.setSandRiverCoarse1622VO(sandRiverCoarse1622VO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中





            SandRiverCoarse2030BVO sandRiverCoarse2330BVO = new SandRiverCoarse2030BVO();
            sandRiverCoarse2330BVO.setSandId(queryVOSecond.getSandIdSandRiverCoarse2330B());/*砂id*/
            sandRiverCoarse2330BVO.setType(queryVOSecond.getModelSandRiverCoarse2330B());/*砂类型*/
            sandRiverCoarse2330BVO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse2330B());/*地区id*/
            sandRiverCoarse2330BVO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse2330B());/*地区名称*/
            sandRiverCoarse2330BVO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse2330B());/*分布*/
            sandRiverCoarse2330BVO.setFineness(queryVOSecond.getFinenessSandRiverCoarse2330B());/*细度*/
            sandRiverCoarse2330BVO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse2330B());/*堆积密度*/
            sandRiverCoarse2330BVO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse2330B());/*精密密度*/
            sandRiverCoarse2330BVO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse2330B());/*表观密度*/
            queryVOSecond.setSandRiverCoarse2330BVO(sandRiverCoarse2330BVO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中





            SandRiverCoarse3137BVO sandRiverCoarse3137BVO = new SandRiverCoarse3137BVO();
            sandRiverCoarse3137BVO.setSandId(queryVOSecond.getSandRiverCoarse3137Id());/*砂id*/
            sandRiverCoarse3137BVO.setType(queryVOSecond.getModelSandRiverCoarse3137());/*砂类型*/
            sandRiverCoarse3137BVO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse3137());/*地区id*/
            sandRiverCoarse3137BVO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse3137());/*地区名称*/
            sandRiverCoarse3137BVO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse3137());/*分布*/
            sandRiverCoarse3137BVO.setFineness(queryVOSecond.getFinenessSandRiverCoarse3137());/*细度*/
            sandRiverCoarse3137BVO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse3137());/*堆积密度*/
            sandRiverCoarse3137BVO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse3137());/*精密密度*/
            sandRiverCoarse3137BVO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse3137());/*表观密度*/
            queryVOSecond.setSandRiverCoarse3137BVO(sandRiverCoarse3137BVO);









            SandRiverCoarse1622BVO sandRiverCoarse1622BVO = new SandRiverCoarse1622BVO();
            sandRiverCoarse1622BVO.setSandId(queryVOSecond.getSandIdSandRiverCoarse1622B());/*砂id*/
            sandRiverCoarse1622BVO.setType(queryVOSecond.getModelSandRiverCoarse1622B());/*砂类型*/
            sandRiverCoarse1622BVO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse1622B());/*地区id*/
            sandRiverCoarse1622BVO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse1622B());/*地区名称*/
            sandRiverCoarse1622BVO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse1622B());/*分布*/
            sandRiverCoarse1622BVO.setFineness(queryVOSecond.getFinenessSandRiverCoarse1622B());/*细度*/
            sandRiverCoarse1622BVO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse1622B());/*堆积密度*/
            sandRiverCoarse1622BVO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse1622B());/*精密密度*/
            sandRiverCoarse1622BVO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse1622B());/*表观密度*/
            queryVOSecond.setSandRiverCoarse1622BVO(sandRiverCoarse1622BVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中








            SandRiverCoarse0475VO sandRiverCoarse0475VO = new SandRiverCoarse0475VO();
            sandRiverCoarse0475VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse0475());/*砂id*/
            sandRiverCoarse0475VO.setType(queryVOSecond.getModelSandRiverCoarse0475());/*砂类型*/
            sandRiverCoarse0475VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse0475());/*地区id*/
            sandRiverCoarse0475VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse0475());/*地区名称*/
            sandRiverCoarse0475VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse0475());/*分布*/
            sandRiverCoarse0475VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse0475());/*细度*/
            sandRiverCoarse0475VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse0475());/*堆积密度*/
            sandRiverCoarse0475VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse0475());/*精密密度*/
            sandRiverCoarse0475VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse0475());/*表观密度*/
            queryVOSecond.setSandRiverCoarse0475VO(sandRiverCoarse0475VO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中


            SandRiverCoarse09VO sandRiverCoarse09VO = new SandRiverCoarse09VO();
            sandRiverCoarse09VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse09());/*砂id*/
            sandRiverCoarse09VO.setType(queryVOSecond.getModelSandRiverCoarse09());/*砂类型*/
            sandRiverCoarse09VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse09());/*地区id*/
            sandRiverCoarse09VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse09());/*地区名称*/
            sandRiverCoarse09VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse09());/*分布*/
            sandRiverCoarse09VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse09());/*细度*/
            sandRiverCoarse09VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse09());/*堆积密度*/
            sandRiverCoarse09VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse09());/*精密密度*/
            sandRiverCoarse09VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse09());/*表观密度*/
            queryVOSecond.setSandRiverCoarse09VO(sandRiverCoarse09VO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中



            //石粉
            SysOtherAdmixturesVO sysOtherAdmixturesVO = new SysOtherAdmixturesVO();
            sysOtherAdmixturesVO.setAdmixturesId(queryVOSecond.getSoaAdmixturesId());
            sysOtherAdmixturesVO.setModel(queryVOSecond.getSoaModel());
            sysOtherAdmixturesVO.setFineness(queryVOSecond.getSoaFineness());
            sysOtherAdmixturesVO.setMoistureContent(queryVOSecond.getSoaMoistureContent());
            sysOtherAdmixturesVO.setActivityIndex28d(queryVOSecond.getSoaActivityIndex28d());
            sysOtherAdmixturesVO.setRegionNameStr(queryVOSecond.getSoaRegionNameStr());
            sysOtherAdmixturesVO.setRegionName(queryVOSecond.getSoaRegionName());


            queryVOSecond.setSysOtherAdmixturesVO(sysOtherAdmixturesVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中


            //矿粉
            SysMineralPowderVO sysMineralPowderVO = new SysMineralPowderVO();
            sysMineralPowderVO.setPowderId(queryVOSecond.getSmpowerPowderId());
            sysMineralPowderVO.setModel(queryVOSecond.getSmpowerModel());
            sysMineralPowderVO.setSlagGrade(queryVOSecond.getSmpowerSlagGrade());
            sysMineralPowderVO.setFineness(queryVOSecond.getSmpowerFineness());
            sysMineralPowderVO.setMoistureContent(queryVOSecond.getSmpowerMoistureContent());
            sysMineralPowderVO.setActivityIndex28d(queryVOSecond.getSmpowerActivityIndex28d());
            sysMineralPowderVO.setRegionName(queryVOSecond.getSmpowerRegionName());
            sysMineralPowderVO.setRegionNameStr(queryVOSecond.getSmpowersmpowerRegionNameStr());
            queryVOSecond.setSysMineralPowderVO(sysMineralPowderVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中


            //煤灰
            SysFlyashVO sysFlyashVO = new SysFlyashVO();
            sysFlyashVO.setFlyashId(queryVOSecond.getSfFlyashId());//粉煤灰id
            sysFlyashVO.setGrade(queryVOSecond.getSfGrade());//型号
            sysFlyashVO.setFineness(queryVOSecond.getSfFineness());//细度
            sysFlyashVO.setRegionName(queryVOSecond.getSfRegionName());//地区
            sysFlyashVO.setRegionNameStr(queryVOSecond.getSfRegionNameStr());
            sysFlyashVO.setFactoryGrade(queryVOSecond.getSfFactoryGrade());//出厂等级
            sysFlyashVO.setMoistureContent(queryVOSecond.getSfMoistureContent());//含水量
            sysFlyashVO.setActivityIndex28d(queryVOSecond.getSfActivityIndex28d());//28天活性指数
            queryVOSecond.setSysFlyashVO(sysFlyashVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中


            //减水剂
            WaterReducerVO waterReducerVO = new WaterReducerVO();
            waterReducerVO.setReducerId(queryVOSecond.getSwrReducerId());/*减水剂id*/
            waterReducerVO.setModel(queryVOSecond.getSwrModel());/*减水剂型号*/
            waterReducerVO.setSourceName(queryVOSecond.getSwrSourceName());/*减水剂来源*/
            waterReducerVO.setSolidContent(queryVOSecond.getSwrSolidContent());/*减水剂含固量*/
            waterReducerVO.setCementPsteFlow(queryVOSecond.getSwrCementPasteFlow());/*减水剂流动度*/
            waterReducerVO.setReducingRate(queryVOSecond.getSwrReducingRate());/*减水剂减水率*/
            queryVOSecond.setWaterReducerVO(waterReducerVO);


            //增效剂
            SysEfficiencyAgentVO sysEfficiencyAgentVO = new SysEfficiencyAgentVO();
            sysEfficiencyAgentVO.setAgentId(queryVOSecond.getSeaAgentId());
            sysEfficiencyAgentVO.setModel(queryVOSecond.getSeaModel());
            sysEfficiencyAgentVO.setSourceName(queryVOSecond.getSeaSourceName());
            queryVOSecond.setSysEfficiencyAgentVO(sysEfficiencyAgentVO);



            //膨胀剂
            SwellingagentVO swellingagentVO = new SwellingagentVO();
            swellingagentVO.setSwellingagentId(queryVOSecond.getSwSwellingagentId());
            swellingagentVO.setModel(queryVOSecond.getSwModel());
            swellingagentVO.setSourceName(queryVOSecond.getSwrSourceName());
            queryVOSecond.setSwellingagentVO(swellingagentVO);


        }

        return queryVOSeconds;
    }

    @Override
    public List<SysMechanicalPerformance> queryMistedMechanicalPerformanceExportExcel(MechanicalPerformanceQueryDTOSecond mechanicalPerformanceQueryDTOSecond) {

        return  sysMechanicalPerformanceMapper.queryMistedMechanicalPerformanceExportExcel(mechanicalPerformanceQueryDTOSecond);
    }


    /**
     * 查询力学性能最大值最小值
     *
     * @param mechanicalPerformanceQueryDTOSecond
     * @return
     */
//    @Override
//    @Transactional
//    public List<MechanicalPerformanceQueryVOSecond> queryMistedMechanicalPerformanceSecond(MechanicalPerformanceQueryDTOSecond mechanicalPerformanceQueryDTOSecond) {
//        List<MechanicalPerformanceQueryVOSecond> queryVOSeconds = sysMechanicalPerformanceMapper.queryMistedMechanicalPerformanceSecond(mechanicalPerformanceQueryDTOSecond);
//        int size = queryVOSeconds.size();
//        for (MechanicalPerformanceQueryVOSecond queryVOSecond : queryVOSeconds) {
//            queryVOSecond.setSize(size);
//
//            SysCementVO sysCementVO = new SysCementVO();
//
//            sysCementVO.setCementId(queryVOSecond.getScCementId());
//            sysCementVO.setModel(queryVOSecond.getScModel());
//            sysCementVO.setRegionName(queryVOSecond.getScRegionName());
//            sysCementVO.setRegionNameStr(queryVOSecond.getScregionNameStr());
//            sysCementVO.setStrengthGrade(queryVOSecond.getScStrengthGrade());
//            sysCementVO.setCaoContent(queryVOSecond.getScCaoContent());
//            sysCementVO.setSio2Content(queryVOSecond.getScSio2Content());
//            sysCementVO.setAl2o3Content(queryVOSecond.getScAl2o3content());
//            sysCementVO.setCompressiveStrength28d(queryVOSecond.getScCompressiveStrength28d());
//
//
//            queryVOSecond.setSysCementVO(sysCementVO);
//
//            // 获取 Stond510VO 对象
//            Stond510VO stond510VO = new Stond510VO();
//            stond510VO.setStoneId(queryVOSecond.getStoneId510());//石头id
//            stond510VO.setModel(queryVOSecond.getModel510());//石头型号
//            stond510VO.setRegionName(queryVOSecond.getRegionName510());//地区id
////            stond510VO.setRegionNameStr(queryVOSecond.getRegionNameStr510());//地区名称
//            stond510VO.setStoneSpecification(queryVOSecond.getStoneSpecification510());//石子规格
//            stond510VO.setStackingDensity(queryVOSecond.getStackingDensity510());//石头堆积密度
//            stond510VO.setCompactDensity(queryVOSecond.getCompactDensity510());//石头精密密度
//            stond510VO.setBulkDensity(queryVOSecond.getBulkdensity510());//石头表观密度
//            queryVOSecond.setStond510VO(stond510VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//            // 获取 Stond525VO 对象
//            Stond525VO stond525VO = new Stond525VO();
//            stond525VO.setStoneId(queryVOSecond.getStoneId525());//石头id
//            stond525VO.setModel(queryVOSecond.getModel525());//石头型号
//            stond525VO.setRegionName(queryVOSecond.getRegionName525());//地区id
////            stond525VO.setRegionNameStr(queryVOSecond.getRegionNameStr525());//地区名称
//            stond525VO.setStoneSpecification(queryVOSecond.getStoneSpecification525());//石子规格
//            stond525VO.setStackingDensity(queryVOSecond.getStackingDensity525());//石头堆积密度
//            stond525VO.setCompactDensity(queryVOSecond.getCompactDensity525());//石头精密密度
//            stond525VO.setBulkDensity(queryVOSecond.getBulkdensity525());//石头表观密度
//            queryVOSecond.setStond525VO(stond525VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//            // 获取 Stond2040VO 对象
//            Stond2040VO stond2040VO = new Stond2040VO();
//            stond2040VO.setStoneId(queryVOSecond.getStoneId2040());//石头id
//            stond2040VO.setModel(queryVOSecond.getModel2040());//石头型号
//            stond2040VO.setRegionName(queryVOSecond.getRegionName2040());//地区id
//            stond2040VO.setRegionNameStr(queryVOSecond.getRegionNameStr2040());//地区名称
//            stond2040VO.setStoneSpecification(queryVOSecond.getStoneSpecification2040());//石子规格
//            stond2040VO.setStackingDensity(queryVOSecond.getStackingDensity2040());//石头堆积密度
//            stond2040VO.setCompactDensity(queryVOSecond.getCompactDensity2040());//石头精密密度
//            stond2040VO.setBulkDensity(queryVOSecond.getBulkdensity2040());//石头表观密度
//            queryVOSecond.setStond2040VO(stond2040VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//            // 获取 Stond2040VO 对象
//            Stond1020VO stond1020VO = new Stond1020VO();
//            stond1020VO.setStoneId(queryVOSecond.getStoneId1020());//石头id
//            stond1020VO.setModel(queryVOSecond.getModel1020());//石头型号
//            stond1020VO.setRegionName(queryVOSecond.getRegionName1020());//地区id
//            stond1020VO.setRegionNameStr(queryVOSecond.getRegionNameStr1020());//地区名称
//            stond1020VO.setStoneSpecification(queryVOSecond.getStoneSpecification1020());//石子规格
//            stond1020VO.setStackingDensity(queryVOSecond.getStackingDensity1020());//石头堆积密度
//            stond1020VO.setCompactDensity(queryVOSecond.getCompactDensity1020());//石头精密密度
//            stond1020VO.setBulkDensity(queryVOSecond.getBulkdensity1020());//石头表观密度
//            queryVOSecond.setStond1020VO(stond1020VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//
//            // 获取 Stond1030VO 对象
//            Stond1030VO stond1030VO = new Stond1030VO();
//            stond1030VO.setStoneId(queryVOSecond.getStoneId1030());//石头id
//            stond1030VO.setModel(queryVOSecond.getModel1030());//石头型号
//            stond1030VO.setRegionName(queryVOSecond.getRegionName1030());//地区id
//            stond1030VO.setRegionNameStr(queryVOSecond.getRegionNameStr1030());//地区名称
//            stond1030VO.setStoneSpecification(queryVOSecond.getStoneSpecification1030());//石子规格
//            stond1030VO.setStackingDensity(queryVOSecond.getStackingDensity1030());//石头堆积密度
//            stond1030VO.setCompactDensity(queryVOSecond.getCompactDensity1030());//石头精密密度
//            stond1030VO.setBulkDensity(queryVOSecond.getBulkdensity1030());//石头表观密度
//            queryVOSecond.setStond1030VO(stond1030VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//            // 获取 Stond1030VO 对象
//            Stond010VO stond010VO = new Stond010VO();
//            stond010VO.setStoneId(queryVOSecond.getStoneId010());//石头id
//            stond010VO.setModel(queryVOSecond.getModel010());//石头型号
//            stond010VO.setRegionName(queryVOSecond.getRegionName010());//地区id
//            stond010VO.setRegionNameStr(queryVOSecond.getRegionNameStr010());//地区名称
//            stond010VO.setStoneSpecification(queryVOSecond.getStoneSpecification010());//石子规格
//            stond010VO.setStackingDensity(queryVOSecond.getStackingDensity010());//石头堆积密度
//            stond010VO.setCompactDensity(queryVOSecond.getCompactDensity010());//石头精密密度
//            stond010VO.setBulkDensity(queryVOSecond.getBulkdensity010());//石头表观密度
//            queryVOSecond.setStond010VO(stond010VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//            // 获取 Stond1030VO 对象
//            Stond2030VO stond2030VO = new Stond2030VO();
//            stond2030VO.setStoneId(queryVOSecond.getStoneId2030());//石头id
//            stond2030VO.setModel(queryVOSecond.getModel2030());//石头型号
//            stond2030VO.setRegionName(queryVOSecond.getRegionName2030());//地区id
//            stond2030VO.setRegionNameStr(queryVOSecond.getRegionNameStr2030());//地区名称
//            stond2030VO.setStoneSpecification(queryVOSecond.getStoneSpecification2030());//石子规格
//            stond2030VO.setStackingDensity(queryVOSecond.getStackingDensity2030());//石头堆积密度
//            stond2030VO.setCompactDensity(queryVOSecond.getCompactDensity2030());//石头精密密度
//            stond2030VO.setBulkDensity(queryVOSecond.getBulkdensity2030());//石头表观密度
//            queryVOSecond.setStond2030VO(stond2030VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//            //砂
//            SandRiverCoarse3137VO sandRiverCoarse3137VO = new SandRiverCoarse3137VO();
//            sandRiverCoarse3137VO.setSandId(queryVOSecond.getSandRiverCoarse3137Id());/*砂id*/
//            sandRiverCoarse3137VO.setType(queryVOSecond.getModelSandRiverCoarse3137());/*砂类型*/
//            sandRiverCoarse3137VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse3137());/*地区id*/
//            sandRiverCoarse3137VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse3137());/*地区名称*/
//            sandRiverCoarse3137VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse3137());/*分布*/
//            sandRiverCoarse3137VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse3137());/*细度*/
//            sandRiverCoarse3137VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse3137());/*堆积密度*/
//            sandRiverCoarse3137VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse3137());/*精密密度*/
//            sandRiverCoarse3137VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse3137());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse3137VO(sandRiverCoarse3137VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//
//
//            SandRiverCoarse2030VO sandRiverCoarse2330VO = new SandRiverCoarse2030VO();
//            sandRiverCoarse2330VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse2330());/*砂id*/
//            sandRiverCoarse2330VO.setType(queryVOSecond.getModelSandRiverCoarse2330());/*砂类型*/
//            sandRiverCoarse2330VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse2330());/*地区id*/
//            sandRiverCoarse2330VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse2330());/*地区名称*/
//            sandRiverCoarse2330VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse2330());/*分布*/
//            sandRiverCoarse2330VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse2330());/*细度*/
//            sandRiverCoarse2330VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse2330());/*堆积密度*/
//            sandRiverCoarse2330VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse2330());/*精密密度*/
//            sandRiverCoarse2330VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse2330());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse2330VO(sandRiverCoarse2330VO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//
//
//
//            SandRiverCoarse1622VO sandRiverCoarse1622VO = new SandRiverCoarse1622VO();
//            sandRiverCoarse1622VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse1622());/*砂id*/
//            sandRiverCoarse1622VO.setType(queryVOSecond.getModelSandRiverCoarse1622());/*砂类型*/
//            sandRiverCoarse1622VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse1622());/*地区id*/
//            sandRiverCoarse1622VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse1622());/*地区名称*/
//            sandRiverCoarse1622VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse1622());/*分布*/
//            sandRiverCoarse1622VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse1622());/*细度*/
//            sandRiverCoarse1622VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse1622());/*堆积密度*/
//            sandRiverCoarse1622VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse1622());/*精密密度*/
//            sandRiverCoarse1622VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse1622());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse1622VO(sandRiverCoarse1622VO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//
//
//            SandRiverCoarse2030BVO sandRiverCoarse2330BVO = new SandRiverCoarse2030BVO();
//            sandRiverCoarse2330BVO.setSandId(queryVOSecond.getSandIdSandRiverCoarse2330B());/*砂id*/
//            sandRiverCoarse2330BVO.setType(queryVOSecond.getModelSandRiverCoarse2330B());/*砂类型*/
//            sandRiverCoarse2330BVO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse2330B());/*地区id*/
//            sandRiverCoarse2330BVO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse2330B());/*地区名称*/
//            sandRiverCoarse2330BVO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse2330B());/*分布*/
//            sandRiverCoarse2330BVO.setFineness(queryVOSecond.getFinenessSandRiverCoarse2330B());/*细度*/
//            sandRiverCoarse2330BVO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse2330B());/*堆积密度*/
//            sandRiverCoarse2330BVO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse2330B());/*精密密度*/
//            sandRiverCoarse2330BVO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse2330B());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse2330BVO(sandRiverCoarse2330BVO);  // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//
//
//            SandRiverCoarse3137BVO sandRiverCoarse3137BVO = new SandRiverCoarse3137BVO();
//            sandRiverCoarse3137BVO.setSandId(queryVOSecond.getSandRiverCoarse3137Id());/*砂id*/
//            sandRiverCoarse3137BVO.setType(queryVOSecond.getModelSandRiverCoarse3137());/*砂类型*/
//            sandRiverCoarse3137BVO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse3137());/*地区id*/
//            sandRiverCoarse3137BVO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse3137());/*地区名称*/
//            sandRiverCoarse3137BVO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse3137());/*分布*/
//            sandRiverCoarse3137BVO.setFineness(queryVOSecond.getFinenessSandRiverCoarse3137());/*细度*/
//            sandRiverCoarse3137BVO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse3137());/*堆积密度*/
//            sandRiverCoarse3137BVO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse3137());/*精密密度*/
//            sandRiverCoarse3137BVO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse3137());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse3137BVO(sandRiverCoarse3137BVO);
//
//
//
//
//
//
//
//
//
//            SandRiverCoarse1622BVO sandRiverCoarse1622BVO = new SandRiverCoarse1622BVO();
//            sandRiverCoarse1622BVO.setSandId(queryVOSecond.getSandIdSandRiverCoarse1622B());/*砂id*/
//            sandRiverCoarse1622BVO.setType(queryVOSecond.getModelSandRiverCoarse1622B());/*砂类型*/
//            sandRiverCoarse1622BVO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse1622B());/*地区id*/
//            sandRiverCoarse1622BVO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse1622B());/*地区名称*/
//            sandRiverCoarse1622BVO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse1622B());/*分布*/
//            sandRiverCoarse1622BVO.setFineness(queryVOSecond.getFinenessSandRiverCoarse1622B());/*细度*/
//            sandRiverCoarse1622BVO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse1622B());/*堆积密度*/
//            sandRiverCoarse1622BVO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse1622B());/*精密密度*/
//            sandRiverCoarse1622BVO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse1622B());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse1622BVO(sandRiverCoarse1622BVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//
//
//
//
//
//            SandRiverCoarse0475VO sandRiverCoarse0475VO = new SandRiverCoarse0475VO();
//            sandRiverCoarse0475VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse0475());/*砂id*/
//            sandRiverCoarse0475VO.setType(queryVOSecond.getModelSandRiverCoarse0475());/*砂类型*/
//            sandRiverCoarse0475VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse0475());/*地区id*/
//            sandRiverCoarse0475VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse0475());/*地区名称*/
//            sandRiverCoarse0475VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse0475());/*分布*/
//            sandRiverCoarse0475VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse0475());/*细度*/
//            sandRiverCoarse0475VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse0475());/*堆积密度*/
//            sandRiverCoarse0475VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse0475());/*精密密度*/
//            sandRiverCoarse0475VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse0475());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse0475VO(sandRiverCoarse0475VO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//            SandRiverCoarse09VO sandRiverCoarse09VO = new SandRiverCoarse09VO();
//            sandRiverCoarse09VO.setSandId(queryVOSecond.getSandIdSandRiverCoarse09());/*砂id*/
//            sandRiverCoarse09VO.setType(queryVOSecond.getModelSandRiverCoarse09());/*砂类型*/
//            sandRiverCoarse09VO.setRegionName(queryVOSecond.getRegionNameSandRiverCoarse09());/*地区id*/
//            sandRiverCoarse09VO.setRegionNameStr(queryVOSecond.getFullNameRsandRiverCoarse09());/*地区名称*/
//            sandRiverCoarse09VO.setParticleSizeDistribution(queryVOSecond.getParticleSizeDistributionNameSandRiverCoarse09());/*分布*/
//            sandRiverCoarse09VO.setFineness(queryVOSecond.getFinenessSandRiverCoarse09());/*细度*/
//            sandRiverCoarse09VO.setBulkDensity(queryVOSecond.getBulkDensitySandRiverCoarse09());/*堆积密度*/
//            sandRiverCoarse09VO.setCompactDensity(queryVOSecond.getCompactDensitySandRiverCoarse09());/*精密密度*/
//            sandRiverCoarse09VO.setApparentDensity(queryVOSecond.getApparentDensitySandRiverCoarse09());/*表观密度*/
//            queryVOSecond.setSandRiverCoarse09VO(sandRiverCoarse09VO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//
//             //石粉
//            SysOtherAdmixturesVO sysOtherAdmixturesVO = new SysOtherAdmixturesVO();
//            sysOtherAdmixturesVO.setAdmixturesId(queryVOSecond.getSoaAdmixturesId());
//            sysOtherAdmixturesVO.setModel(queryVOSecond.getSoaModel());
//            sysOtherAdmixturesVO.setFineness(queryVOSecond.getSoaFineness());
//            sysOtherAdmixturesVO.setMoistureContent(queryVOSecond.getSoaMoistureContent());
//            sysOtherAdmixturesVO.setActivityIndex28d(queryVOSecond.getSoaActivityIndex28d());
//            sysOtherAdmixturesVO.setRegionNameStr(queryVOSecond.getSoaRegionNameStr());
//            sysOtherAdmixturesVO.setRegionName(queryVOSecond.getSoaRegionName());
//
//
//            queryVOSecond.setSysOtherAdmixturesVO(sysOtherAdmixturesVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//            //矿粉
//            SysMineralPowderVO sysMineralPowderVO = new SysMineralPowderVO();
//            sysMineralPowderVO.setPowderId(queryVOSecond.getSmpowerPowderId());
//            sysMineralPowderVO.setModel(queryVOSecond.getSmpowerModel());
//            sysMineralPowderVO.setSlagGrade(queryVOSecond.getSmpowerSlagGrade());
//            sysMineralPowderVO.setFineness(queryVOSecond.getSmpowerFineness());
//            sysMineralPowderVO.setMoistureContent(queryVOSecond.getSmpowerMoistureContent());
//            sysMineralPowderVO.setActivityIndex28d(queryVOSecond.getSmpowerActivityIndex28d());
//            sysMineralPowderVO.setRegionName(queryVOSecond.getSmpowerRegionName());
//            sysMineralPowderVO.setRegionNameStr(queryVOSecond.getSmpowersmpowerRegionNameStr());
//            queryVOSecond.setSysMineralPowderVO(sysMineralPowderVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//            //煤灰
//            SysFlyashVO sysFlyashVO = new SysFlyashVO();
//            sysFlyashVO.setFlyashId(queryVOSecond.getSfFlyashId());//粉煤灰id
//            sysFlyashVO.setGrade(queryVOSecond.getSfGrade());//型号
//            sysFlyashVO.setFineness(queryVOSecond.getSfFineness());//细度
//            sysFlyashVO.setRegionName(queryVOSecond.getSfRegionName());//地区
//            sysFlyashVO.setRegionNameStr(queryVOSecond.getSfRegionNameStr());
//            sysFlyashVO.setFactoryGrade(queryVOSecond.getSfFactoryGrade());//出厂等级
//            sysFlyashVO.setMoistureContent(queryVOSecond.getSfMoistureContent());//含水量
//            sysFlyashVO.setActivityIndex28d(queryVOSecond.getSfActivityIndex28d());//28天活性指数
//            queryVOSecond.setSysFlyashVO(sysFlyashVO); // 设置回 MechanicalPerformanceQueryVOSecond 对象中
//
//
//            //减水剂
//            WaterReducerVO waterReducerVO = new WaterReducerVO();
//            waterReducerVO.setReducerId(queryVOSecond.getSwrReducerId());/*减水剂id*/
//            waterReducerVO.setModel(queryVOSecond.getSwrModel());/*减水剂型号*/
//            waterReducerVO.setSourceName(queryVOSecond.getSwrSourceName());/*减水剂来源*/
//            waterReducerVO.setSolidContent(queryVOSecond.getSwrSolidContent());/*减水剂含固量*/
//            waterReducerVO.setCementPsteFlow(queryVOSecond.getSwrCementPasteFlow());/*减水剂流动度*/
//            waterReducerVO.setReducingRate(queryVOSecond.getSwrReducingRate());/*减水剂减水率*/
//            queryVOSecond.setWaterReducerVO(waterReducerVO);
//
//
//            //增效剂
//            SysEfficiencyAgentVO sysEfficiencyAgentVO = new SysEfficiencyAgentVO();
//            sysEfficiencyAgentVO.setAgentId(queryVOSecond.getSeaAgentId());
//            sysEfficiencyAgentVO.setModel(queryVOSecond.getSeaModel());
//            sysEfficiencyAgentVO.setSourceName(queryVOSecond.getSeaSourceName());
//            queryVOSecond.setSysEfficiencyAgentVO(sysEfficiencyAgentVO);
//
//
//
//            //膨胀剂
//            SwellingagentVO swellingagentVO = new SwellingagentVO();
//            swellingagentVO.setSwellingagentId(queryVOSecond.getSwSwellingagentId());
//            swellingagentVO.setModel(queryVOSecond.getSwModel());
//            swellingagentVO.setSourceName(queryVOSecond.getSwrSourceName());
//            queryVOSecond.setSwellingagentVO(swellingagentVO);
//
//
//        }
//
//        return queryVOSeconds;
//    }

}
